Reporting Samples
Easily create richly formatted spreadsheet reports without Excel
Excel Reporting With the wide adoption of Microsoft Excel, there is no substitute for taking advantage of spreadsheet components in your Microsoft .NET Framework projects. You can use SpreadsheetGear for .NET to deliver spreadsheet reports in a variety of ways. The following samples show some basic ways to create spreadsheet content in Windows Forms projects, and are easily adaptable to a wide range of Microsoft .NET solutions.
Simple Spreadsheet Report
Add values to a workbook displayed in a WorkbookView control.
Spreadsheet Report with Formulas and Formatting
Add values, formulas, defined names and formatting to a workbook displayed in a WorkbookView control.
DataTable to Workbook
Copy data from a DataTable to a workbook and display it in a WorkbookView control.
DataSet to Workbook
Insert data from multiple DataTables, merge this data with formatting and formulas from a template workbook, and display it in a WorkbookView control.
Workbook Consolidation
Utilize the IRange.Copy method to dynamically copy and consolidate data from multiple workbooks.